Export as Delimited Text File
Overview
This function lets you export data from Lotto Sorcerer into a delimited text
file. This is useful for backing up data, importing the data into an SQL
database, as well as sharing data with another user of Lotto Sorcerer. The
file you export can be easily imported back into the program.
Please note that unregistered versions of Lotto Sorcerer are limited to 50
records for exporting.
How to Invoke
Use the menu item "Lottery Data > Export Lottery Data > Export as
Delimited Text File...".
Basic Procedure
- Select the lottery you want to export.
- Choose the export parameters.
- Click the "Export" button.
Window Controls
"Select Lottery" dropdown
Choose the lottery you want to export.
"Date Format" dropdown
Choose the exact date format you want to use.
Four Digit Years checkbox
If checked, the data will be exported as four-digit years (for example,
'2005'); if unchecked only the last two digits are exported (for example,
'2005' will be exported as '05'). Note that if you choose "[nothing]" as the
character between Date Elements, this checkbox will be checked
automatically.
Two Digit Years Month, Day
If checked, the data will be exported as two-digit months and days (for
example, '01/09/2013'); if unchecked, these values will have only one digit
(for example, '1/9/2013'). Note that if you choose "[nothing]" as the
character between Date Elements, this checkbox will be checked
automatically.
"Character Between Date Elements" dropdown
Choose the character that separates the year, month and day parts in the
date field.
"Character Between Date and Numbers" dropdown
Choose the character that separates the date field and the number fields.
"Character Between Numbers" dropdown
Choose the character that separates the different number fields.
Two Digit Numbers
If checked, single digit numbers will be zero padded. For example,
'1-2-5-16-19' will be exported as '01-02-05-16-19'. If you chose "[nothing]
as the character between numbers, this will be checked automatically.
"End-of-Line Terminator" dropdown
Different operating systems use different characters to mark the end of
line. Choose the appropriate one.